package com.ztesoft.web.common.db.arg;

import java.util.*;
import java.math.*;
import org.apache.commons.lang.*;

public class BillingCycleArg {
    private String pk_name = "BILLING_CYCLE_ID";

    private String orderByClause;

    private String groupByClause;

    private String columns;

    private String countsql1;

    private String countsql2;

    private boolean distinct;

    private int rowStart = 0;

    private int rowEnd = 10;

    private List<BillingCycleCriteria> oredCriteria;

    public BillingCycleArg() {
        oredCriteria = new ArrayList<BillingCycleCriteria>();
    }

    public void setPk_name(String pk_name) {
        this.pk_name = StringEscapeUtils.escapeSql(pk_name);
    }

    public String getPk_name() {
        return pk_name;
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = StringEscapeUtils.escapeSql(orderByClause);
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setGroupByClause(String groupByClause) {
        this.groupByClause = StringEscapeUtils.escapeSql(groupByClause);
    }

    public String geGroupByClause() {
        return groupByClause;
    }

    public void setColumns(String columns) {
        this.columns = StringEscapeUtils.escapeSql(columns);
    }

    public String geColumns() {
        return columns;
    }

    public void setCountsql1(String countsql1) {
        this.countsql1 = StringEscapeUtils.escapeSql(countsql1);
    }

    public String geCountsql1() {
        return countsql1;
    }

    public void setCountsql2(String countsql2) {
        this.countsql2 = StringEscapeUtils.escapeSql(countsql2);
    }

    public String geCountsql2() {
        return countsql2;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public void setRowStart(int rowStart) {
        this.rowStart = rowStart;
    }

    public void setRowEnd(int rowEnd) {
        this.rowEnd = rowEnd;
    }

    public int getRowStart() {
        return rowStart;
    }

    public int getRowEnd() {
        return rowEnd;
    }

    public List<BillingCycleCriteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(BillingCycleCriteria criteria) {
        oredCriteria.add(criteria);
    }

    public BillingCycleCriteria or() {
    	BillingCycleCriteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public BillingCycleCriteria createCriteria() {
    	BillingCycleCriteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected BillingCycleCriteria createCriteriaInternal() {
    	BillingCycleCriteria criteria = new BillingCycleCriteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        groupByClause = null;
        columns = null;
        countsql1 = null;
        countsql2 = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<BillingCycleCriterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<BillingCycleCriterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<BillingCycleCriterion> getAllCriteria() {
            return criteria;
        }

        public List<BillingCycleCriterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new BillingCycleCriterion(condition));
        }

        protected void addCriterion(String condition, Object value,
                String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property
                        + " cannot be null");
            }
            criteria.add(new BillingCycleCriterion(condition, value));
        }

        protected void addCriterion(String condition, Object value,
                String property, int likeType) {
            if (value == null) {
                throw new RuntimeException("Value for " + property
                        + " cannot be null");
            }
            criteria.add(new BillingCycleCriterion(condition, value, likeType));
        }

        protected void addCriterion(String condition, Object value1,
                Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property
                        + " cannot be null");
            }
            criteria.add(new BillingCycleCriterion(condition, value1, value2));
        }

        public BillingCycleCriteria andCriterionEqualTo(String criterion) {
            if (StringUtils.isBlank(criterion)) {
                criterion = "1=1";
            }
            addCriterion(criterion);
            return (BillingCycleCriteria) this;
        }
        public BillingCycleCriteria andBillingCycleIdIsNull() {
            addCriterion("BILLING_CYCLE_ID is null");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBillingCycleIdIsNotNull() {
            addCriterion("BILLING_CYCLE_ID is not null");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBillingCycleIdEqualTo(Integer value) {
            addCriterion("BILLING_CYCLE_ID =", value, "BILLING_CYCLE_ID");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBillingCycleIdNotEqualTo(Integer value) {
            addCriterion("BILLING_CYCLE_ID <>", value, "BILLING_CYCLE_ID");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBillingCycleIdGreaterThan(Integer value) {
            addCriterion("BILLING_CYCLE_ID >", value, "BILLING_CYCLE_ID");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBillingCycleIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("BILLING_CYCLE_ID >=", value, "BILLING_CYCLE_ID");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBillingCycleIdLessThan(Integer value) {
            addCriterion("BILLING_CYCLE_ID <", value, "BILLING_CYCLE_ID");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBillingCycleIdLessThanOrEqualTo(Integer value) {
            addCriterion("BILLING_CYCLE_ID <=", value, "BILLING_CYCLE_ID");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBillingCycleIdLike(Integer value) {
            addCriterion("BILLING_CYCLE_ID like ", value, "BILLING_CYCLE_ID", 1);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBillingCycleIdNotLike(Integer value) {
            addCriterion("BILLING_CYCLE_ID  not like ", value, "BILLING_CYCLE_ID", 1);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBillingCycleIdLeftLike(Integer value) {
            addCriterion("BILLING_CYCLE_ID like ", value, "BILLING_CYCLE_ID", 0);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBillingCycleIdNotLeftLike(Integer value) {
            addCriterion("BILLING_CYCLE_ID  not like ", value, "BILLING_CYCLE_ID", 0);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBillingCycleIdRightLike(Integer value) {
            addCriterion("BILLING_CYCLE_ID like ", value, "BILLING_CYCLE_ID", 2);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBillingCycleIdNotRightLike(Integer value) {
            addCriterion("BILLING_CYCLE_ID  not like ", value, "BILLING_CYCLE_ID", 2);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBillingCycleIdIn(List<Integer> values) {
            addCriterion("BILLING_CYCLE_ID  in ", values, "BILLING_CYCLE_ID");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBillingCycleIdNotIn(List<Integer> values) {
            addCriterion("BILLING_CYCLE_ID not in ", values, "BILLING_CYCLE_ID");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBillingCycleIdBetween(Integer value1, Integer value2) {
            addCriterion("BILLING_CYCLE_ID between ", value1, value2, "BILLING_CYCLE_ID");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBillingCycleIdNotBetween(Integer value1, Integer value2) {
            addCriterion("BILLING_CYCLE_ID not between ", value1, value2, "BILLING_CYCLE_ID");
            return (BillingCycleCriteria) this;
        }
        public BillingCycleCriteria andBillingCycleTypeIdIsNull() {
            addCriterion("BILLING_CYCLE_TYPE_ID is null");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBillingCycleTypeIdIsNotNull() {
            addCriterion("BILLING_CYCLE_TYPE_ID is not null");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBillingCycleTypeIdEqualTo(Integer value) {
            addCriterion("BILLING_CYCLE_TYPE_ID =", value, "BILLING_CYCLE_TYPE_ID");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBillingCycleTypeIdNotEqualTo(Integer value) {
            addCriterion("BILLING_CYCLE_TYPE_ID <>", value, "BILLING_CYCLE_TYPE_ID");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBillingCycleTypeIdGreaterThan(Integer value) {
            addCriterion("BILLING_CYCLE_TYPE_ID >", value, "BILLING_CYCLE_TYPE_ID");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBillingCycleTypeIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("BILLING_CYCLE_TYPE_ID >=", value, "BILLING_CYCLE_TYPE_ID");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBillingCycleTypeIdLessThan(Integer value) {
            addCriterion("BILLING_CYCLE_TYPE_ID <", value, "BILLING_CYCLE_TYPE_ID");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBillingCycleTypeIdLessThanOrEqualTo(Integer value) {
            addCriterion("BILLING_CYCLE_TYPE_ID <=", value, "BILLING_CYCLE_TYPE_ID");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBillingCycleTypeIdLike(Integer value) {
            addCriterion("BILLING_CYCLE_TYPE_ID like ", value, "BILLING_CYCLE_TYPE_ID", 1);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBillingCycleTypeIdNotLike(Integer value) {
            addCriterion("BILLING_CYCLE_TYPE_ID  not like ", value, "BILLING_CYCLE_TYPE_ID", 1);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBillingCycleTypeIdLeftLike(Integer value) {
            addCriterion("BILLING_CYCLE_TYPE_ID like ", value, "BILLING_CYCLE_TYPE_ID", 0);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBillingCycleTypeIdNotLeftLike(Integer value) {
            addCriterion("BILLING_CYCLE_TYPE_ID  not like ", value, "BILLING_CYCLE_TYPE_ID", 0);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBillingCycleTypeIdRightLike(Integer value) {
            addCriterion("BILLING_CYCLE_TYPE_ID like ", value, "BILLING_CYCLE_TYPE_ID", 2);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBillingCycleTypeIdNotRightLike(Integer value) {
            addCriterion("BILLING_CYCLE_TYPE_ID  not like ", value, "BILLING_CYCLE_TYPE_ID", 2);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBillingCycleTypeIdIn(List<Integer> values) {
            addCriterion("BILLING_CYCLE_TYPE_ID  in ", values, "BILLING_CYCLE_TYPE_ID");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBillingCycleTypeIdNotIn(List<Integer> values) {
            addCriterion("BILLING_CYCLE_TYPE_ID not in ", values, "BILLING_CYCLE_TYPE_ID");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBillingCycleTypeIdBetween(Integer value1, Integer value2) {
            addCriterion("BILLING_CYCLE_TYPE_ID between ", value1, value2, "BILLING_CYCLE_TYPE_ID");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBillingCycleTypeIdNotBetween(Integer value1, Integer value2) {
            addCriterion("BILLING_CYCLE_TYPE_ID not between ", value1, value2, "BILLING_CYCLE_TYPE_ID");
            return (BillingCycleCriteria) this;
        }
        public BillingCycleCriteria andLastBillingCycleIdIsNull() {
            addCriterion("LAST_BILLING_CYCLE_ID is null");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andLastBillingCycleIdIsNotNull() {
            addCriterion("LAST_BILLING_CYCLE_ID is not null");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andLastBillingCycleIdEqualTo(Integer value) {
            addCriterion("LAST_BILLING_CYCLE_ID =", value, "LAST_BILLING_CYCLE_ID");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andLastBillingCycleIdNotEqualTo(Integer value) {
            addCriterion("LAST_BILLING_CYCLE_ID <>", value, "LAST_BILLING_CYCLE_ID");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andLastBillingCycleIdGreaterThan(Integer value) {
            addCriterion("LAST_BILLING_CYCLE_ID >", value, "LAST_BILLING_CYCLE_ID");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andLastBillingCycleIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("LAST_BILLING_CYCLE_ID >=", value, "LAST_BILLING_CYCLE_ID");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andLastBillingCycleIdLessThan(Integer value) {
            addCriterion("LAST_BILLING_CYCLE_ID <", value, "LAST_BILLING_CYCLE_ID");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andLastBillingCycleIdLessThanOrEqualTo(Integer value) {
            addCriterion("LAST_BILLING_CYCLE_ID <=", value, "LAST_BILLING_CYCLE_ID");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andLastBillingCycleIdLike(Integer value) {
            addCriterion("LAST_BILLING_CYCLE_ID like ", value, "LAST_BILLING_CYCLE_ID", 1);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andLastBillingCycleIdNotLike(Integer value) {
            addCriterion("LAST_BILLING_CYCLE_ID  not like ", value, "LAST_BILLING_CYCLE_ID", 1);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andLastBillingCycleIdLeftLike(Integer value) {
            addCriterion("LAST_BILLING_CYCLE_ID like ", value, "LAST_BILLING_CYCLE_ID", 0);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andLastBillingCycleIdNotLeftLike(Integer value) {
            addCriterion("LAST_BILLING_CYCLE_ID  not like ", value, "LAST_BILLING_CYCLE_ID", 0);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andLastBillingCycleIdRightLike(Integer value) {
            addCriterion("LAST_BILLING_CYCLE_ID like ", value, "LAST_BILLING_CYCLE_ID", 2);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andLastBillingCycleIdNotRightLike(Integer value) {
            addCriterion("LAST_BILLING_CYCLE_ID  not like ", value, "LAST_BILLING_CYCLE_ID", 2);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andLastBillingCycleIdIn(List<Integer> values) {
            addCriterion("LAST_BILLING_CYCLE_ID  in ", values, "LAST_BILLING_CYCLE_ID");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andLastBillingCycleIdNotIn(List<Integer> values) {
            addCriterion("LAST_BILLING_CYCLE_ID not in ", values, "LAST_BILLING_CYCLE_ID");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andLastBillingCycleIdBetween(Integer value1, Integer value2) {
            addCriterion("LAST_BILLING_CYCLE_ID between ", value1, value2, "LAST_BILLING_CYCLE_ID");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andLastBillingCycleIdNotBetween(Integer value1, Integer value2) {
            addCriterion("LAST_BILLING_CYCLE_ID not between ", value1, value2, "LAST_BILLING_CYCLE_ID");
            return (BillingCycleCriteria) this;
        }
        public BillingCycleCriteria andCycleBeginDateIsNull() {
            addCriterion("CYCLE_BEGIN_DATE is null");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleBeginDateIsNotNull() {
            addCriterion("CYCLE_BEGIN_DATE is not null");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleBeginDateEqualTo(String value) {
            addCriterion("CYCLE_BEGIN_DATE =", value, "CYCLE_BEGIN_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleBeginDateNotEqualTo(String value) {
            addCriterion("CYCLE_BEGIN_DATE <>", value, "CYCLE_BEGIN_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleBeginDateGreaterThan(String value) {
            addCriterion("CYCLE_BEGIN_DATE >", value, "CYCLE_BEGIN_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleBeginDateGreaterThanOrEqualTo(String value) {
            addCriterion("CYCLE_BEGIN_DATE >=", value, "CYCLE_BEGIN_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleBeginDateLessThan(String value) {
            addCriterion("CYCLE_BEGIN_DATE <", value, "CYCLE_BEGIN_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleBeginDateLessThanOrEqualTo(String value) {
            addCriterion("CYCLE_BEGIN_DATE <=", value, "CYCLE_BEGIN_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleBeginDateLike(String value) {
            addCriterion("CYCLE_BEGIN_DATE like ", value, "CYCLE_BEGIN_DATE", 1);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleBeginDateNotLike(String value) {
            addCriterion("CYCLE_BEGIN_DATE  not like ", value, "CYCLE_BEGIN_DATE", 1);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleBeginDateLeftLike(String value) {
            addCriterion("CYCLE_BEGIN_DATE like ", value, "CYCLE_BEGIN_DATE", 0);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleBeginDateNotLeftLike(String value) {
            addCriterion("CYCLE_BEGIN_DATE  not like ", value, "CYCLE_BEGIN_DATE", 0);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleBeginDateRightLike(String value) {
            addCriterion("CYCLE_BEGIN_DATE like ", value, "CYCLE_BEGIN_DATE", 2);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleBeginDateNotRightLike(String value) {
            addCriterion("CYCLE_BEGIN_DATE  not like ", value, "CYCLE_BEGIN_DATE", 2);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleBeginDateIn(List<String> values) {
            addCriterion("CYCLE_BEGIN_DATE  in ", values, "CYCLE_BEGIN_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleBeginDateNotIn(List<String> values) {
            addCriterion("CYCLE_BEGIN_DATE not in ", values, "CYCLE_BEGIN_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleBeginDateBetween(String value1, String value2) {
            addCriterion("CYCLE_BEGIN_DATE between ", value1, value2, "CYCLE_BEGIN_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleBeginDateNotBetween(String value1, String value2) {
            addCriterion("CYCLE_BEGIN_DATE not between ", value1, value2, "CYCLE_BEGIN_DATE");
            return (BillingCycleCriteria) this;
        }
        public BillingCycleCriteria andCycleEndDateIsNull() {
            addCriterion("CYCLE_END_DATE is null");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleEndDateIsNotNull() {
            addCriterion("CYCLE_END_DATE is not null");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleEndDateEqualTo(String value) {
            addCriterion("CYCLE_END_DATE =", value, "CYCLE_END_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleEndDateNotEqualTo(String value) {
            addCriterion("CYCLE_END_DATE <>", value, "CYCLE_END_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleEndDateGreaterThan(String value) {
            addCriterion("CYCLE_END_DATE >", value, "CYCLE_END_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleEndDateGreaterThanOrEqualTo(String value) {
            addCriterion("CYCLE_END_DATE >=", value, "CYCLE_END_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleEndDateLessThan(String value) {
            addCriterion("CYCLE_END_DATE <", value, "CYCLE_END_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleEndDateLessThanOrEqualTo(String value) {
            addCriterion("CYCLE_END_DATE <=", value, "CYCLE_END_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleEndDateLike(String value) {
            addCriterion("CYCLE_END_DATE like ", value, "CYCLE_END_DATE", 1);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleEndDateNotLike(String value) {
            addCriterion("CYCLE_END_DATE  not like ", value, "CYCLE_END_DATE", 1);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleEndDateLeftLike(String value) {
            addCriterion("CYCLE_END_DATE like ", value, "CYCLE_END_DATE", 0);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleEndDateNotLeftLike(String value) {
            addCriterion("CYCLE_END_DATE  not like ", value, "CYCLE_END_DATE", 0);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleEndDateRightLike(String value) {
            addCriterion("CYCLE_END_DATE like ", value, "CYCLE_END_DATE", 2);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleEndDateNotRightLike(String value) {
            addCriterion("CYCLE_END_DATE  not like ", value, "CYCLE_END_DATE", 2);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleEndDateIn(List<String> values) {
            addCriterion("CYCLE_END_DATE  in ", values, "CYCLE_END_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleEndDateNotIn(List<String> values) {
            addCriterion("CYCLE_END_DATE not in ", values, "CYCLE_END_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleEndDateBetween(String value1, String value2) {
            addCriterion("CYCLE_END_DATE between ", value1, value2, "CYCLE_END_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleEndDateNotBetween(String value1, String value2) {
            addCriterion("CYCLE_END_DATE not between ", value1, value2, "CYCLE_END_DATE");
            return (BillingCycleCriteria) this;
        }
        public BillingCycleCriteria andDueDateIsNull() {
            addCriterion("DUE_DATE is null");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andDueDateIsNotNull() {
            addCriterion("DUE_DATE is not null");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andDueDateEqualTo(String value) {
            addCriterion("DUE_DATE =", value, "DUE_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andDueDateNotEqualTo(String value) {
            addCriterion("DUE_DATE <>", value, "DUE_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andDueDateGreaterThan(String value) {
            addCriterion("DUE_DATE >", value, "DUE_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andDueDateGreaterThanOrEqualTo(String value) {
            addCriterion("DUE_DATE >=", value, "DUE_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andDueDateLessThan(String value) {
            addCriterion("DUE_DATE <", value, "DUE_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andDueDateLessThanOrEqualTo(String value) {
            addCriterion("DUE_DATE <=", value, "DUE_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andDueDateLike(String value) {
            addCriterion("DUE_DATE like ", value, "DUE_DATE", 1);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andDueDateNotLike(String value) {
            addCriterion("DUE_DATE  not like ", value, "DUE_DATE", 1);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andDueDateLeftLike(String value) {
            addCriterion("DUE_DATE like ", value, "DUE_DATE", 0);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andDueDateNotLeftLike(String value) {
            addCriterion("DUE_DATE  not like ", value, "DUE_DATE", 0);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andDueDateRightLike(String value) {
            addCriterion("DUE_DATE like ", value, "DUE_DATE", 2);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andDueDateNotRightLike(String value) {
            addCriterion("DUE_DATE  not like ", value, "DUE_DATE", 2);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andDueDateIn(List<String> values) {
            addCriterion("DUE_DATE  in ", values, "DUE_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andDueDateNotIn(List<String> values) {
            addCriterion("DUE_DATE not in ", values, "DUE_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andDueDateBetween(String value1, String value2) {
            addCriterion("DUE_DATE between ", value1, value2, "DUE_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andDueDateNotBetween(String value1, String value2) {
            addCriterion("DUE_DATE not between ", value1, value2, "DUE_DATE");
            return (BillingCycleCriteria) this;
        }
        public BillingCycleCriteria andBlockDateIsNull() {
            addCriterion("BLOCK_DATE is null");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBlockDateIsNotNull() {
            addCriterion("BLOCK_DATE is not null");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBlockDateEqualTo(String value) {
            addCriterion("BLOCK_DATE =", value, "BLOCK_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBlockDateNotEqualTo(String value) {
            addCriterion("BLOCK_DATE <>", value, "BLOCK_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBlockDateGreaterThan(String value) {
            addCriterion("BLOCK_DATE >", value, "BLOCK_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBlockDateGreaterThanOrEqualTo(String value) {
            addCriterion("BLOCK_DATE >=", value, "BLOCK_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBlockDateLessThan(String value) {
            addCriterion("BLOCK_DATE <", value, "BLOCK_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBlockDateLessThanOrEqualTo(String value) {
            addCriterion("BLOCK_DATE <=", value, "BLOCK_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBlockDateLike(String value) {
            addCriterion("BLOCK_DATE like ", value, "BLOCK_DATE", 1);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBlockDateNotLike(String value) {
            addCriterion("BLOCK_DATE  not like ", value, "BLOCK_DATE", 1);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBlockDateLeftLike(String value) {
            addCriterion("BLOCK_DATE like ", value, "BLOCK_DATE", 0);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBlockDateNotLeftLike(String value) {
            addCriterion("BLOCK_DATE  not like ", value, "BLOCK_DATE", 0);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBlockDateRightLike(String value) {
            addCriterion("BLOCK_DATE like ", value, "BLOCK_DATE", 2);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBlockDateNotRightLike(String value) {
            addCriterion("BLOCK_DATE  not like ", value, "BLOCK_DATE", 2);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBlockDateIn(List<String> values) {
            addCriterion("BLOCK_DATE  in ", values, "BLOCK_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBlockDateNotIn(List<String> values) {
            addCriterion("BLOCK_DATE not in ", values, "BLOCK_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBlockDateBetween(String value1, String value2) {
            addCriterion("BLOCK_DATE between ", value1, value2, "BLOCK_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andBlockDateNotBetween(String value1, String value2) {
            addCriterion("BLOCK_DATE not between ", value1, value2, "BLOCK_DATE");
            return (BillingCycleCriteria) this;
        }
        public BillingCycleCriteria andStateIsNull() {
            addCriterion("STATE is null");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andStateIsNotNull() {
            addCriterion("STATE is not null");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andStateEqualTo(String value) {
            addCriterion("STATE =", value, "STATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andStateNotEqualTo(String value) {
            addCriterion("STATE <>", value, "STATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andStateGreaterThan(String value) {
            addCriterion("STATE >", value, "STATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andStateGreaterThanOrEqualTo(String value) {
            addCriterion("STATE >=", value, "STATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andStateLessThan(String value) {
            addCriterion("STATE <", value, "STATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andStateLessThanOrEqualTo(String value) {
            addCriterion("STATE <=", value, "STATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andStateLike(String value) {
            addCriterion("STATE like ", value, "STATE", 1);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andStateNotLike(String value) {
            addCriterion("STATE  not like ", value, "STATE", 1);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andStateLeftLike(String value) {
            addCriterion("STATE like ", value, "STATE", 0);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andStateNotLeftLike(String value) {
            addCriterion("STATE  not like ", value, "STATE", 0);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andStateRightLike(String value) {
            addCriterion("STATE like ", value, "STATE", 2);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andStateNotRightLike(String value) {
            addCriterion("STATE  not like ", value, "STATE", 2);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andStateIn(List<String> values) {
            addCriterion("STATE  in ", values, "STATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andStateNotIn(List<String> values) {
            addCriterion("STATE not in ", values, "STATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andStateBetween(String value1, String value2) {
            addCriterion("STATE between ", value1, value2, "STATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andStateNotBetween(String value1, String value2) {
            addCriterion("STATE not between ", value1, value2, "STATE");
            return (BillingCycleCriteria) this;
        }
        public BillingCycleCriteria andStateDateIsNull() {
            addCriterion("STATE_DATE is null");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andStateDateIsNotNull() {
            addCriterion("STATE_DATE is not null");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andStateDateEqualTo(String value) {
            addCriterion("STATE_DATE =", value, "STATE_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andStateDateNotEqualTo(String value) {
            addCriterion("STATE_DATE <>", value, "STATE_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andStateDateGreaterThan(String value) {
            addCriterion("STATE_DATE >", value, "STATE_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andStateDateGreaterThanOrEqualTo(String value) {
            addCriterion("STATE_DATE >=", value, "STATE_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andStateDateLessThan(String value) {
            addCriterion("STATE_DATE <", value, "STATE_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andStateDateLessThanOrEqualTo(String value) {
            addCriterion("STATE_DATE <=", value, "STATE_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andStateDateLike(String value) {
            addCriterion("STATE_DATE like ", value, "STATE_DATE", 1);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andStateDateNotLike(String value) {
            addCriterion("STATE_DATE  not like ", value, "STATE_DATE", 1);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andStateDateLeftLike(String value) {
            addCriterion("STATE_DATE like ", value, "STATE_DATE", 0);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andStateDateNotLeftLike(String value) {
            addCriterion("STATE_DATE  not like ", value, "STATE_DATE", 0);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andStateDateRightLike(String value) {
            addCriterion("STATE_DATE like ", value, "STATE_DATE", 2);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andStateDateNotRightLike(String value) {
            addCriterion("STATE_DATE  not like ", value, "STATE_DATE", 2);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andStateDateIn(List<String> values) {
            addCriterion("STATE_DATE  in ", values, "STATE_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andStateDateNotIn(List<String> values) {
            addCriterion("STATE_DATE not in ", values, "STATE_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andStateDateBetween(String value1, String value2) {
            addCriterion("STATE_DATE between ", value1, value2, "STATE_DATE");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andStateDateNotBetween(String value1, String value2) {
            addCriterion("STATE_DATE not between ", value1, value2, "STATE_DATE");
            return (BillingCycleCriteria) this;
        }
        public BillingCycleCriteria andCycleCcFlagIsNull() {
            addCriterion("cycle_cc_flag is null");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleCcFlagIsNotNull() {
            addCriterion("cycle_cc_flag is not null");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleCcFlagEqualTo(String value) {
            addCriterion("cycle_cc_flag =", value, "cycle_cc_flag");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleCcFlagNotEqualTo(String value) {
            addCriterion("cycle_cc_flag <>", value, "cycle_cc_flag");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleCcFlagGreaterThan(String value) {
            addCriterion("cycle_cc_flag >", value, "cycle_cc_flag");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleCcFlagGreaterThanOrEqualTo(String value) {
            addCriterion("cycle_cc_flag >=", value, "cycle_cc_flag");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleCcFlagLessThan(String value) {
            addCriterion("cycle_cc_flag <", value, "cycle_cc_flag");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleCcFlagLessThanOrEqualTo(String value) {
            addCriterion("cycle_cc_flag <=", value, "cycle_cc_flag");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleCcFlagLike(String value) {
            addCriterion("cycle_cc_flag like ", value, "cycle_cc_flag", 1);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleCcFlagNotLike(String value) {
            addCriterion("cycle_cc_flag  not like ", value, "cycle_cc_flag", 1);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleCcFlagLeftLike(String value) {
            addCriterion("cycle_cc_flag like ", value, "cycle_cc_flag", 0);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleCcFlagNotLeftLike(String value) {
            addCriterion("cycle_cc_flag  not like ", value, "cycle_cc_flag", 0);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleCcFlagRightLike(String value) {
            addCriterion("cycle_cc_flag like ", value, "cycle_cc_flag", 2);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleCcFlagNotRightLike(String value) {
            addCriterion("cycle_cc_flag  not like ", value, "cycle_cc_flag", 2);
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleCcFlagIn(List<String> values) {
            addCriterion("cycle_cc_flag  in ", values, "cycle_cc_flag");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleCcFlagNotIn(List<String> values) {
            addCriterion("cycle_cc_flag not in ", values, "cycle_cc_flag");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleCcFlagBetween(String value1, String value2) {
            addCriterion("cycle_cc_flag between ", value1, value2, "cycle_cc_flag");
            return (BillingCycleCriteria) this;
        }

        public BillingCycleCriteria andCycleCcFlagNotBetween(String value1, String value2) {
            addCriterion("cycle_cc_flag not between ", value1, value2, "cycle_cc_flag");
            return (BillingCycleCriteria) this;
        }

    }

    public static class BillingCycleCriteria extends GeneratedCriteria {

        protected BillingCycleCriteria() {
            super();
        }
    }

    public static class BillingCycleCriterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected BillingCycleCriterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }
        protected BillingCycleCriterion(String condition, Object value, int likeType) {
            this.condition = condition;
            if (likeType == 0) {
                this.value = "%" + value;
            }
            else if (likeType == 1) {
                this.value = "%" + value + "%";
            }
            else {
                this.value = value + "%";
            }
            this.typeHandler = null;
            this.singleValue = true;

        }

        protected BillingCycleCriterion(String condition, Object value,
                String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            }
            else {
                this.singleValue = true;
            }
        }

        protected BillingCycleCriterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected BillingCycleCriterion(String condition, Object value,
                Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected BillingCycleCriterion(String condition, Object value,
                Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}